abnormal_msg= [
    "[{guid: 7f698e44-12d6-42ff-8a66-129820a118b2, diff_value: -6.69999999999709}]",
    "[{guid: e78d7538-9abf-4530-831f-2b0565c0e27a, diff_value: -25.906999999991967}]",
    "[{guid: 6ffe8e09-42a2-4caa-a8b7-474097503b33, diff_value: -5.0}]",
    "[{guid: 6ffe8e09-42a2-4caa-a8b7-474097503b33, diff_value: -0.19500000000698492}]",
    "[{guid: 6ffe8e09-42a2-4caa-a8b7-474097503b33, diff_value: -0.40699999999196734}]",
    "[]",
    "[{guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -2.2960000000020955}]",
    "[]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.900000000000091}, {guid: e78d7538-9abf-4530-831f-2b0565c0e27a, diff_value: -18.60099999999511}]",
    "[{guid: 6ffe8e09-42a2-4caa-a8b7-474097503b33, diff_value: -2.5}]",
    "[]",
    "[{guid: 6ffe8e09-42a2-4caa-a8b7-474097503b33, diff_value: -0.20399999999790452}]",
    "[{guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -1.8980000000010477}]",
    "[{guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -0.5}]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -0.09900000000197906}, {guid: 6ffe8e09-42a2-4caa-a8b7-474097503b33, diff_value: -1.8980000000010477}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -0.5}]",
    "[{guid: 02a5c720-2b3b-423a-b199-716a72dfde3c, diff_value: -22.5}]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -0.09900000000197906}]",
    "[{guid: 4504378d-63c1-40a8-b9ae-d9ab0106ed53, diff_value: -0.7999999999997272}, {guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -3.199000000000524}]",
    "[]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -0.19999999999708962}, {guid: 989f2297-017a-4877-b804-03f614da5a90, diff_value: -2.3980000000010477}]",
    "[]",
    "[{guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -0.7960000000020955}]",
    "[]",
    "[]",
    "[]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -0.09900000000197906}]",
    "[{guid: 6ffe8e09-42a2-4caa-a8b7-474097503b33, diff_value: -14.5}, {guid: 752f4462-e91a-49e0-8ee3-c59b9ab31089, diff_value: -3.2000000000007276}]",
    "[]",
    "[{guid: 7450da9e-9e77-4d94-b619-40038fcb19d0, diff_value: -7.2039999999979045}]",
    "[]",
    "[{guid: e78d7538-9abf-4530-831f-2b0565c0e27a, diff_value: -43.20299999999406}]",
    "[{guid: 7450da9e-9e77-4d94-b619-40038fcb19d0, diff_value: -2.199000000000524}]",
    "[]",
    "[]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.7989999999990687}]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.3000000000029104}]",
    "[]",
    "[]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.40099999999802094}]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.5}]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -0.09900000000197906}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.10000000000013642}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.09900000000197906}]",
    "[{guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -1.6019999999989523}]",
    "[{guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -0.4000000000014552}]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.10000000000013642}]",
    "[{guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -0.1000000000003638}]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -3.400999999998021}]",
    "[{guid: 7f698e44-12d6-42ff-8a66-129820a118b2, diff_value: -1.1999999999970896}]",
    "[{guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -0.7999999999992724}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.30099999999947613}]",
    "[{guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -0.2000000000007276}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.5990000000019791}, {guid: fb66b800-5f67-4e78-9b4d-d71f141e8558, diff_value: -2.0970000000015716}]",
    "[{guid: 6fcaae48-fd0e-4855-9d6e-7a7f32da469b, diff_value: -0.1999999999998181}]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -2.199000000000524}]",
    "[]",
    "[{guid: 4e26f0b2-571f-4ebc-8a6d-5fe5e7fe588f, diff_value: -0.1999999999998181}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.10000000000013642}]",
    "[]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -2.900000000001455}, {guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -7.200000000000728}]",
    "[]",
    "[]",
    "[]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.10000000000013642}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -12.0}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -7.199000000000524}]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -1.8009999999994761}]",
    "[]",
    "[{guid: 02a5c720-2b3b-423a-b199-716a72dfde3c, diff_value: -7.300999999999476}, {guid: 6f1bec35-d521-4b33-8cba-3dfa3422551f, diff_value: -3.8000000000010914}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -8.100000000000364}, {guid: e78d7538-9ab",
    "[{guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -6.400000000001455}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -0.3000000000010914}]",
    "[]",
    "[{guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -0.8999999999996362}]",
    "[{guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -0.7999999999992724}]",
    "[{guid: 7450da9e-9e77-4d94-b619-40038fcb19d0, diff_value: -23.199000000000524}]",
    "[{guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -0.2000000000007276}, {guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -12.0}]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.900000000000091}, {guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -1.6999999999989086}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -0.2000000000007276}]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -2.5}]",
    "[{guid: b23aca89-c8a2-4569-bdd4-b3692f6a0918, diff_value: -0.10000000000002274}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.5}]",
    "[]",
    "[{guid: 989f2297-017a-4877-b804-03f614da5a90, diff_value: -3.300999999999476}]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.2999999999999545}]",
    "[]",
    "[]",
    "[{guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -5.699999999998909}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -0.6000000000003638}]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.10000000000013642}]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -0.9009999999980209}]",
    "[{guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -0.6990000000005239}]",
    "[{guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -0.1999999999989086}]",
    "[]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.20000000000004547}]",
    "[]",
    "[]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -9.400999999998021}]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -0.8000000000029104}]",
    "[]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -1.5999999999985448}, {guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -8.600000000000364}, {guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -6.199000000000524}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.6019999999989523}, {guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -0.8980000000010477}]",
    "[]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -1.0970000000015716}]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.599999999999909}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -1.0}]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.5999999999994543}, {guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -10.199999999998909}]",
    "[{guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -0.0970000000015716}]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.1999999999998181}]",
    "[{guid: 3e0ff980-3766-4da2-b74f-e61d8dae3852, diff_value: -0.20000000000004547}, {guid: 81a65026-e69f-4b87-ae24-fa841efa4f33, diff_value: -3.0}, {guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -2.399999999999636}, {guid: d09ce9c4-f5e9-49ab-9758-7",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.7999999999992724}, {guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -0.8980000000010477}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.4029999999984284}, {guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.10000000000013642}]",
    "[{guid: 218b979d-59b1-400a-b523-e89f21dd87fd, diff_value: -15.300999999999476}]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.3000000000001819}, {guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -5.799999999999272}, {guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -0.19900000000052387}]",
    "[{guid: 2d7bc8d6-adb8-430c-b054-0a4f948dd46b, diff_value: -4.399999999999636}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.6000000000001364}, {guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.2999999999999545}]",
    "[{guid: b23aca89-c8a2-4569-bdd4-b3692f6a0918, diff_value: -0.10000000000002274}, {guid: d09ce9c4-f5e9-49ab-9758-78c4e94d3cde, diff_value: -0.1999999999998181}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.8009999999994761}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.10000000000013642}]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.1999999999998181}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.4000000000014552}]",
    "[{guid: 71382452-c68f-42c4-a21c-8fa096d026ca, diff_value: -24.599999999998545}]",
    "[{guid: d09ce9c4-f5e9-49ab-9758-78c4e94d3cde, diff_value: -0.0999999999994543}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -1.0999999999985448}]",
    "[{guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -13.200000000000728}, {guid: d09ce9c4-f5e9-49ab-9758-78c4e94d3cde, diff_value: -0.1999999999998181}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.8980000000010477}, {guid: 5aa120f1-0acd-4f77-a7cb-3dc75c7d462a, diff_value: -0.1999999999999318}, {guid: 81a65026-e69f-4b87-ae24-fa841efa4f33, diff_value: -2.600000000000364}]",
    "[]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.5}]",
    "[{guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -7.100000000000364}, {guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.6000000000001364}]",
    "[]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.30099999999947613}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -8.199000000000524}]",
    "[{guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.2999999999999545}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.10199999999895226}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.6000000000001364}, {guid: d09ce9c4-f5e9-49ab-9758-78c4e94d3cde, diff_value: -0.0999999999994543}]",
    "[{guid: 71382452-c68f-42c4-a21c-8fa096d026ca, diff_value: -37.39800000000105}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.4000000000014552}]",
    "[{guid: 5aa120f1-0acd-4f77-a7cb-3dc75c7d462a, diff_value: -0.2999999999999545}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -1.1990000000005239}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -1.4029999999984284}, {guid: d09ce9c4-f5e9-49ab-9758-78c4e94d3cde, diff_value: -0.8999999999996362}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -1.6999999999970896}]",
    "[]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -1.5970000000015716}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.10000000000013642}, {guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -1.300000000000182}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.5}, {guid: c648eac4-1403-4b03-b889-c9f7fc3b2867, diff_value: -0.6000000000000227}]",
    "[]",
    "[{guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -11.199999999998909}]",
    "[]",
    "[{guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.2999999999999545}]",
    "[]",
    "[{guid: bee63756-e359-4e68-96be-c829af7fde04, diff_value: -4.400000000000091}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.19900000000052387}]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.8009999999994761}]",
    "[]",
    "[]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.6000000000003638}, {guid: bd0b2b16-15f6-4e87-8e32-f4c7d0e26f74, diff_value: -3.2000000000000455}]",
    "[{guid: 752f4462-e91a-49e0-8ee3-c59b9ab31089, diff_value: -10.700000000000728}, {guid: d09ce9c4-f5e9-49ab-9758-78c4e94d3cde, diff_value: -1.1000000000003638}]",
    "[{guid: 0b7878c5-ab73-4e1d-b55f-0c5bcd135841, diff_value: -1.5999999999994543}, {guid: 7450da9e-9e77-4d94-b619-40038fcb19d0, diff_value: -23.703999999997905}, {guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -1.2999999999992724}]",
    "[{guid: d09ce9c4-f5e9-49ab-9758-78c4e94d3cde, diff_value: -0.0999999999994543}]",
    "[]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.10000000000013642}, {guid: c648eac4-1403-4b03-b889-c9f7fc3b2867, diff_value: -0.30000000000001137}]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.6999999999998181}, {guid: ad6adac0-74e7-4d62-bf1c-5bcc4c3d2d75, diff_value: -5.2960000000020955}]",
    "[]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -1.0}]",
    "[{guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -10.899999999999636}]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.9000000000005457}]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.5999999999994543}, {guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -1.2999999999999545}]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.09900000000197906}]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.1000000000003638}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.40099999999802094}]",
    "[]",
    "[{guid: 2a710553-e11d-4d9d-95da-dd0fe3272aaa, diff_value: -33.400000000001455}, {guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.5999999999994543}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.7010000000009313}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -3.9029999999984284}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -15.5}, {guid: d09ce9c4-f5e9-49ab-9758-78c4e94d3cde, diff_value: -0.1000000000003638}, {guid: d0ba6cb8-739d-47e5-92cc-",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.6999999999998181}]",
    "[{guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -0.39800000000104774}]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.40099999999802094}]",
    "[{guid: 3e0ff980-3766-4da2-b74f-e61d8dae3852, diff_value: -0.20000000000004547}, {guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.4000000000005457}]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.0999999999994543}, {guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.6000000000001364}, {guid: e78d7538-9abf-4530-831f-2b0565c0e27a, diff_value: -33.79700000000594}]",
    "[]",
    "[]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -1.0}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -0.1999999999989086}, {guid: d09ce9c4-f5e9-49ab-9758-78c4e94d3cde, diff_value: -1.300000000000182}, {guid: f1cd97b3-4a06-4e16-ac44-99",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -13.300999999999476}, {guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.2999999999999545}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.4029999999984284}]",
    "[]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.10199999999895226}, {guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -4.899999999999636}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.20100000000093132}]",
    "[{guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -0.1000000000003638}]",
    "[]",
    "[{guid: 1a72ae64-ba59-4fd2-a605-f2a288990bbc, diff_value: -0.8999999999998636}, {guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.0970000000015716}]",
    "[{guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -18.699000000000524}]",
    "[{guid: 8e7b09e4-16ae-484d-9af4-3ec70f52cef4, diff_value: -0.0999999999994543}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -2.6019999999989523}]",
    "[{guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.1999999999998181}]",
    "[{guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -1.7989999999990687}]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.599999999999909}, {guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.3999999999996362}, {guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.2999999999999545}, {guid: b5b4ccea-ba",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -0.6019999999989523}, {guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.30099999999947613}, {guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.1000000000003638}, {guid: 8c9aaf8e-",
    "[]",
    "[]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -3.0}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.2999999999999545}, {guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.5}, {guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, di",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.19900000000052387}]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -0.3000000000001819}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -1.4029999999984284}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.09999999999990905}, {guid: 9d332a32-d6ae-4c2b-8f84-49fa48aa020a, diff_value: -0.10000000000002274}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.39800000000104774}]",
    "[]",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -3.1019999999989523}]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.20000000000004547}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.6019999999989523}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.09999999999990905}]",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -0.10199999999895226}]",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -0.10199999999895226}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -9.400999999998021}]",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -0.0970000000015716}, {guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -9.699000000000524}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -0.5}]",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -0.10199999999895226}]",
    "[{guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -3.5}, {guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.10000000000013642}]",
    "[]",
    "[]",
    "[]",
    "[]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -1.3980000000010477}]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -5.900000000000091}, {guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -1.0}, {guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -3.7010000000009313}, {guid: 6f1bec35-d521-4b33-8cba-3d",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -1.2039999999979045}, {guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -1.3980000000010477}]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -0.8000000000001819}, {guid: 3e0ff980-3766-4da2-b74f-e61d8dae3852, diff_value: -0.20000000000004547}, {guid: 4504378d-63c1-40a8-b9ae-d9ab0106ed53, diff_value: -1.900000000000091}, {guid: 546c0b17-e",
    "[]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -0.09999999999990905}, {guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -1.2039999999979045}, {guid: f1cd97b3-4a06-4e16-ac44-998d486e9683, diff_value: -1.8980000000010477}]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -0.09999999999990905}, {guid: 3b90509a-2835-40dc-aa40-9fab94cfa8c7, diff_value: -3.2010000000009313}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -1.7000000000007276}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -5.097000000001572}, {guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -7.099999999998545}]",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -3.300999999999476}]",
    "[]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -0.3000000000001819}, {guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -1.3009999999994761}]",
    "[]",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -0.19900000000052387}, {guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.40000000000009095}]",
    "[]",
    "[]",
    "[]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.0970000000015716}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -11.799999999999272}]",
    "[{guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -15.299999999999272}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.8980000000010477}, {guid: 8f04132a-5506-4f91-81e9-ad7c58d68bb9, diff_value: -0.5}, {guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -1.6019999999989523}]",
    "[]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -0.5}]",
    "[]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -0.40000000000009095}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.5}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -2.599999999998545}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.5}]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -0.599999999999909}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.09999999999990905}]",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -0.4029999999984284}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -1.0}]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -0.1999999999998181}, {guid: 8c9aaf8e-097b-495a-8db1-3307453a3c99, diff_value: -13.799999999999272}]",
    "[]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -0.20000000000027285}]",
    "[{guid: de151ff4-a604-4e25-b378-005baea79d41, diff_value: -0.900000000000091}]",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -0.5}]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -0.20000000000027285}, {guid: de151ff4-a604-4e25-b378-005baea79d41, diff_value: -0.20000000000027285}]",
    "[{guid: 41816e23-a979-43c0-ad71-5cbfdea65953, diff_value: -0.39800000000104774}, {guid: 8b710a4a-0161-4f5c-b8d2-99f8b4261453, diff_value: -1.0}]",
    "[{guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.599999999999909}]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -1.0}]",
    "[{guid: 0b7878c5-ab73-4e1d-b55f-0c5bcd135841, diff_value: -6.5}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.09999999999990905}]",
    "[]",
    "[{guid: 6f1bec35-d521-4b33-8cba-3dfa3422551f, diff_value: -8.600000000000364}]",
    "[{guid: 5aa120f1-0acd-4f77-a7cb-3dc75c7d462a, diff_value: -0.09999999999990905}, {guid: b5b4ccea-baed-4fae-9aab-0389c7f3fd42, diff_value: -2.5}]",
    "[{guid: 02a5c720-2b3b-423a-b199-716a72dfde3c, diff_value: -1.9029999999984284}, {guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -0.6999999999998181}]",
    "[]",
    "[]",
    "[]",
    "[]",
    "[]",
    "[]",
    "[]",
    "[{guid: 5aa120f1-0acd-4f77-a7cb-3dc75c7d462a, diff_value: -0.5}]",
    "[]",
    "[{guid: e78d7538-9abf-4530-831f-2b0565c0e27a, diff_value: -53.804999999993015}, {guid: f7a3cde7-c93a-49cd-b43b-a51a084ed672, diff_value: -1.699999999999818}]",
    "[]",
    "[]",
    "[{guid: 0748c447-e11d-430d-b3a5-bc83ae04a02e, diff_value: -3.0}, {guid: 5aa120f1-0acd-4f77-a7cb-3dc75c7d462a, diff_value: -0.10000000000002274}]",
    "[]",
    "[{guid: 7450da9e-9e77-4d94-b619-40038fcb19d0, diff_value: -6.101999999998952}]",
    "[]",
    "[]",
    "[]",
    "[]",
    "[{guid: 3e0ff980-3766-4da2-b74f-e61d8dae3852, diff_value: -0.5}]",
    "[]",
    "[{guid: 6fcaae48-fd0e-4855-9d6e-7a7f32da469b, diff_value: -0.5999999999994543}]",
    "[]",
    "[]",
    "[]",
    "[]",
    "[]",
    "[]",
    "[]",
    "[{guid: d0ba6cb8-739d-47e5-92cc-59cd84e9de10, diff_value: -0.2960000000020955}]",
    "[]",
    "[]",
    "[{guid: eddd7abf-5d16-479c-b1d3-9fac09c0c403, diff_value: -51.10199999999895}]",
    "[]",
    "[]",
    "[]",
    "[{guid: 218b979d-59b1-400a-b523-e89f21dd87fd, diff_value: -1.3009999999994761}, {guid: 38ff875f-9ae9-4f81-a917-1ea2b36ea457, diff_value: -2.200000000000273}]",
    "[{guid: 15052bfc-3de1-4d4c-a794-088e4d6ff223, diff_value: -2.599999999999909}]",
    "[]",
    "[{guid: eddd7abf-5d16-479c-b1d3-9fac09c0c403, diff_value: -30.699000000000524}]",
    "[]",
    "[]",
    "[{guid: 3e0ff980-3766-4da2-b74f-e61d8dae3852, diff_value: -0.7000000000000455}]",
    "[]",
    "[]",
    "[{guid: 4e26f0b2-571f-4ebc-8a6d-5fe5e7fe588f, diff_value: -0.6999999999998181}]",
    "[{guid: 36c84fac-5161-4267-8196-a02381a83aaf, diff_value: -0.5}]",
    "[]",
    "[]",
    "[]",
    "[{guid: 8ef90930-446b-4053-94a9-bd7cf54f3398, diff_value: -1.5}]",
    "[]",
    "[{guid: 4e26f0b2-571f-4ebc-8a6d-5fe5e7fe588f, diff_value: -0.3000000000001819}]",
    "[]",
    "[{guid: 1e34bc0d-a29b-4ae7-afce-a29a8e095411, diff_value: -7.600000000000364}, {guid: 546c0b17-ee89-4c4a-86f3-6df57c183809, diff_value: -0.40000000000009095}, {guid: e78d7538-9abf-4530-831f-2b0565c0e27a, diff_value: -33.09300000000803}]"
]
import re



list_guid = []
for k in abnormal_msg:
    pattern=r"guid: (\w+-\w+-\w+-\w+-\w+)"
    matches = re.findall(pattern, k)
    print(matches)
    for j in matches:
        list_guid.append(j)


from collections import Counter

counter = Counter(list_guid)


duplicates = {item for item, count in counter.items() if count > 1}

duplicates_str=', '.join("'{}'".format(item)for item in duplicates)


sql_abnornal_entprise="""select id,ent_name from elec_enterprise_info
where 
id in (
select ent_id from  elec_dev_info
where id in (
select devid from elecdata_basic_info 
where guid in (
'de151ff4-a604-4e25-b378-005baea79d41', '8c9aaf8e-097b-495a-8db1-3307453a3c99', 'eddd7abf-5d16-479c-b1d3-9fac09c0c403', '989f2297-017a-4877-b804-03f614da5a90', '36c84fac-5161-4267-8196-a02381a83aaf', '15052bfc-3de1-4d4c-a794-088e4d6ff223', '71382452-c68f-42c4-a21c-8fa096d026ca', '3b90509a-2835-40dc-aa40-9fab94cfa8c7', 'c648eac4-1403-4b03-b889-c9f7fc3b2867', '6fcaae48-fd0e-4855-9d6e-7a7f32da469b', '41816e23-a979-43c0-ad71-5cbfdea65953', '0b7878c5-ab73-4e1d-b55f-0c5bcd135841', 'f1cd97b3-4a06-4e16-ac44-998d486e9683', '8f04132a-5506-4f91-81e9-ad7c58d68bb9', '6f1bec35-d521-4b33-8cba-3dfa3422551f', '02a5c720-2b3b-423a-b199-716a72dfde3c', '752f4462-e91a-49e0-8ee3-c59b9ab31089', '4504378d-63c1-40a8-b9ae-d9ab0106ed53', '7f698e44-12d6-42ff-8a66-129820a118b2', '546c0b17-ee89-4c4a-86f3-6df57c183809', '4e26f0b2-571f-4ebc-8a6d-5fe5e7fe588f', '8b710a4a-0161-4f5c-b8d2-99f8b4261453', '6ffe8e09-42a2-4caa-a8b7-474097503b33', 'd0ba6cb8-739d-47e5-92cc-59cd84e9de10', '218b979d-59b1-400a-b523-e89f21dd87fd', '3e0ff980-3766-4da2-b74f-e61d8dae3852', 'd09ce9c4-f5e9-49ab-9758-78c4e94d3cde', 'e78d7538-9abf-4530-831f-2b0565c0e27a', 'b5b4ccea-baed-4fae-9aab-0389c7f3fd42', '81a65026-e69f-4b87-ae24-fa841efa4f33', 'b23aca89-c8a2-4569-bdd4-b3692f6a0918', '5aa120f1-0acd-4f77-a7cb-3dc75c7d462a', '7450da9e-9e77-4d94-b619-40038fcb19d0'
))) """

print()

